/*
 Navicat Premium Data Transfer

 Source Server         : 阿里云
 Source Server Type    : MySQL
 Source Server Version : 50733
 Source Host           : 101.37.30.31:3306
 Source Schema         : blog

 Target Server Type    : MySQL
 Target Server Version : 50733
 File Encoding         : 65001

 Date: 20/07/2021 14:16:27
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for cities
-- ----------------------------
DROP TABLE IF EXISTS `cities`;
CREATE TABLE `cities` (
  `id` smallint(4) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) NOT NULL DEFAULT '' COMMENT '城市名称',
  `city_code` mediumint(6) unsigned NOT NULL DEFAULT '0' COMMENT '城市代码',
  `province_code` mediumint(6) unsigned NOT NULL DEFAULT '0' COMMENT '省份代码',
  PRIMARY KEY (`id`),
  KEY `province_code` (`province_code`)
) ENGINE=InnoDB AUTO_INCREMENT=361 DEFAULT CHARSET=utf8 COMMENT='城市表';

-- ----------------------------
-- Records of cities
-- ----------------------------
BEGIN;
INSERT INTO `cities` VALUES (1, '直辖市', 110100, 110000);
INSERT INTO `cities` VALUES (2, '直辖市', 120100, 120000);
INSERT INTO `cities` VALUES (3, '石家庄市', 130100, 130000);
INSERT INTO `cities` VALUES (4, '唐山市', 130200, 130000);
INSERT INTO `cities` VALUES (5, '秦皇岛市', 130300, 130000);
INSERT INTO `cities` VALUES (6, '邯郸市', 130400, 130000);
INSERT INTO `cities` VALUES (7, '邢台市', 130500, 130000);
INSERT INTO `cities` VALUES (8, '保定市', 130600, 130000);
INSERT INTO `cities` VALUES (9, '张家口市', 130700, 130000);
INSERT INTO `cities` VALUES (10, '承德市', 130800, 130000);
INSERT INTO `cities` VALUES (11, '沧州市', 130900, 130000);
INSERT INTO `cities` VALUES (12, '廊坊市', 131000, 130000);
INSERT INTO `cities` VALUES (13, '衡水市', 131100, 130000);
INSERT INTO `cities` VALUES (14, '太原市', 140100, 140000);
INSERT INTO `cities` VALUES (15, '大同市', 140200, 140000);
INSERT INTO `cities` VALUES (16, '阳泉市', 140300, 140000);
INSERT INTO `cities` VALUES (17, '长治市', 140400, 140000);
INSERT INTO `cities` VALUES (18, '晋城市', 140500, 140000);
INSERT INTO `cities` VALUES (19, '朔州市', 140600, 140000);
INSERT INTO `cities` VALUES (20, '晋中市', 140700, 140000);
INSERT INTO `cities` VALUES (21, '运城市', 140800, 140000);
INSERT INTO `cities` VALUES (22, '忻州市', 140900, 140000);
INSERT INTO `cities` VALUES (23, '临汾市', 141000, 140000);
INSERT INTO `cities` VALUES (24, '吕梁市', 141100, 140000);
INSERT INTO `cities` VALUES (25, '呼和浩特市', 150100, 150000);
INSERT INTO `cities` VALUES (26, '包头市', 150200, 150000);
INSERT INTO `cities` VALUES (27, '乌海市', 150300, 150000);
INSERT INTO `cities` VALUES (28, '赤峰市', 150400, 150000);
INSERT INTO `cities` VALUES (29, '通辽市', 150500, 150000);
INSERT INTO `cities` VALUES (30, '鄂尔多斯市', 150600, 150000);
INSERT INTO `cities` VALUES (31, '呼伦贝尔市', 150700, 150000);
INSERT INTO `cities` VALUES (32, '巴彦淖尔市', 150800, 150000);
INSERT INTO `cities` VALUES (33, '乌兰察布市', 150900, 150000);
INSERT INTO `cities` VALUES (34, '兴安盟', 152200, 150000);
INSERT INTO `cities` VALUES (35, '锡林郭勒盟', 152500, 150000);
INSERT INTO `cities` VALUES (36, '阿拉善盟', 152900, 150000);
INSERT INTO `cities` VALUES (37, '沈阳市', 210100, 210000);
INSERT INTO `cities` VALUES (38, '大连市', 210200, 210000);
INSERT INTO `cities` VALUES (39, '鞍山市', 210300, 210000);
INSERT INTO `cities` VALUES (40, '抚顺市', 210400, 210000);
INSERT INTO `cities` VALUES (41, '本溪市', 210500, 210000);
INSERT INTO `cities` VALUES (42, '丹东市', 210600, 210000);
INSERT INTO `cities` VALUES (43, '锦州市', 210700, 210000);
INSERT INTO `cities` VALUES (44, '营口市', 210800, 210000);
INSERT INTO `cities` VALUES (45, '阜新市', 210900, 210000);
INSERT INTO `cities` VALUES (46, '辽阳市', 211000, 210000);
INSERT INTO `cities` VALUES (47, '盘锦市', 211100, 210000);
INSERT INTO `cities` VALUES (48, '铁岭市', 211200, 210000);
INSERT INTO `cities` VALUES (49, '朝阳市', 211300, 210000);
INSERT INTO `cities` VALUES (50, '葫芦岛市', 211400, 210000);
INSERT INTO `cities` VALUES (51, '长春市', 220100, 220000);
INSERT INTO `cities` VALUES (52, '吉林市', 220200, 220000);
INSERT INTO `cities` VALUES (53, '四平市', 220300, 220000);
INSERT INTO `cities` VALUES (54, '辽源市', 220400, 220000);
INSERT INTO `cities` VALUES (55, '通化市', 220500, 220000);
INSERT INTO `cities` VALUES (56, '白山市', 220600, 220000);
INSERT INTO `cities` VALUES (57, '松原市', 220700, 220000);
INSERT INTO `cities` VALUES (58, '白城市', 220800, 220000);
INSERT INTO `cities` VALUES (59, '延边朝鲜族自治州', 222400, 220000);
INSERT INTO `cities` VALUES (60, '哈尔滨市', 230100, 230000);
INSERT INTO `cities` VALUES (61, '齐齐哈尔市', 230200, 230000);
INSERT INTO `cities` VALUES (62, '鸡西市', 230300, 230000);
INSERT INTO `cities` VALUES (63, '鹤岗市', 230400, 230000);
INSERT INTO `cities` VALUES (64, '双鸭山市', 230500, 230000);
INSERT INTO `cities` VALUES (65, '大庆市', 230600, 230000);
INSERT INTO `cities` VALUES (66, '伊春市', 230700, 230000);
INSERT INTO `cities` VALUES (67, '佳木斯市', 230800, 230000);
INSERT INTO `cities` VALUES (68, '七台河市', 230900, 230000);
INSERT INTO `cities` VALUES (69, '牡丹江市', 231000, 230000);
INSERT INTO `cities` VALUES (70, '黑河市', 231100, 230000);
INSERT INTO `cities` VALUES (71, '绥化市', 231200, 230000);
INSERT INTO `cities` VALUES (72, '大兴安岭地区', 232700, 230000);
INSERT INTO `cities` VALUES (73, '直辖市', 310100, 310000);
INSERT INTO `cities` VALUES (74, '南京市', 320100, 320000);
INSERT INTO `cities` VALUES (75, '无锡市', 320200, 320000);
INSERT INTO `cities` VALUES (76, '徐州市', 320300, 320000);
INSERT INTO `cities` VALUES (77, '常州市', 320400, 320000);
INSERT INTO `cities` VALUES (78, '苏州市', 320500, 320000);
INSERT INTO `cities` VALUES (79, '南通市', 320600, 320000);
INSERT INTO `cities` VALUES (80, '连云港市', 320700, 320000);
INSERT INTO `cities` VALUES (81, '淮安市', 320800, 320000);
INSERT INTO `cities` VALUES (82, '盐城市', 320900, 320000);
INSERT INTO `cities` VALUES (83, '扬州市', 321000, 320000);
INSERT INTO `cities` VALUES (84, '镇江市', 321100, 320000);
INSERT INTO `cities` VALUES (85, '泰州市', 321200, 320000);
INSERT INTO `cities` VALUES (86, '宿迁市', 321300, 320000);
INSERT INTO `cities` VALUES (87, '杭州市', 330100, 330000);
INSERT INTO `cities` VALUES (88, '宁波市', 330200, 330000);
INSERT INTO `cities` VALUES (89, '温州市', 330300, 330000);
INSERT INTO `cities` VALUES (90, '嘉兴市', 330400, 330000);
INSERT INTO `cities` VALUES (91, '湖州市', 330500, 330000);
INSERT INTO `cities` VALUES (92, '绍兴市', 330600, 330000);
INSERT INTO `cities` VALUES (93, '金华市', 330700, 330000);
INSERT INTO `cities` VALUES (94, '衢州市', 330800, 330000);
INSERT INTO `cities` VALUES (95, '舟山市', 330900, 330000);
INSERT INTO `cities` VALUES (96, '台州市', 331000, 330000);
INSERT INTO `cities` VALUES (97, '丽水市', 331100, 330000);
INSERT INTO `cities` VALUES (98, '合肥市', 340100, 340000);
INSERT INTO `cities` VALUES (99, '芜湖市', 340200, 340000);
INSERT INTO `cities` VALUES (100, '蚌埠市', 340300, 340000);
INSERT INTO `cities` VALUES (101, '淮南市', 340400, 340000);
INSERT INTO `cities` VALUES (102, '马鞍山市', 340500, 340000);
INSERT INTO `cities` VALUES (103, '淮北市', 340600, 340000);
INSERT INTO `cities` VALUES (104, '铜陵市', 340700, 340000);
INSERT INTO `cities` VALUES (105, '安庆市', 340800, 340000);
INSERT INTO `cities` VALUES (106, '黄山市', 341000, 340000);
INSERT INTO `cities` VALUES (107, '滁州市', 341100, 340000);
INSERT INTO `cities` VALUES (108, '阜阳市', 341200, 340000);
INSERT INTO `cities` VALUES (109, '宿州市', 341300, 340000);
INSERT INTO `cities` VALUES (110, '六安市', 341500, 340000);
INSERT INTO `cities` VALUES (111, '亳州市', 341600, 340000);
INSERT INTO `cities` VALUES (112, '池州市', 341700, 340000);
INSERT INTO `cities` VALUES (113, '宣城市', 341800, 340000);
INSERT INTO `cities` VALUES (114, '福州市', 350100, 350000);
INSERT INTO `cities` VALUES (115, '厦门市', 350200, 350000);
INSERT INTO `cities` VALUES (116, '莆田市', 350300, 350000);
INSERT INTO `cities` VALUES (117, '三明市', 350400, 350000);
INSERT INTO `cities` VALUES (118, '泉州市', 350500, 350000);
INSERT INTO `cities` VALUES (119, '漳州市', 350600, 350000);
INSERT INTO `cities` VALUES (120, '南平市', 350700, 350000);
INSERT INTO `cities` VALUES (121, '龙岩市', 350800, 350000);
INSERT INTO `cities` VALUES (122, '宁德市', 350900, 350000);
INSERT INTO `cities` VALUES (123, '南昌市', 360100, 360000);
INSERT INTO `cities` VALUES (124, '景德镇市', 360200, 360000);
INSERT INTO `cities` VALUES (125, '萍乡市', 360300, 360000);
INSERT INTO `cities` VALUES (126, '九江市', 360400, 360000);
INSERT INTO `cities` VALUES (127, '新余市', 360500, 360000);
INSERT INTO `cities` VALUES (128, '鹰潭市', 360600, 360000);
INSERT INTO `cities` VALUES (129, '赣州市', 360700, 360000);
INSERT INTO `cities` VALUES (130, '吉安市', 360800, 360000);
INSERT INTO `cities` VALUES (131, '宜春市', 360900, 360000);
INSERT INTO `cities` VALUES (132, '抚州市', 361000, 360000);
INSERT INTO `cities` VALUES (133, '上饶市', 361100, 360000);
INSERT INTO `cities` VALUES (134, '济南市', 370100, 370000);
INSERT INTO `cities` VALUES (135, '青岛市', 370200, 370000);
INSERT INTO `cities` VALUES (136, '淄博市', 370300, 370000);
INSERT INTO `cities` VALUES (137, '枣庄市', 370400, 370000);
INSERT INTO `cities` VALUES (138, '东营市', 370500, 370000);
INSERT INTO `cities` VALUES (139, '烟台市', 370600, 370000);
INSERT INTO `cities` VALUES (140, '潍坊市', 370700, 370000);
INSERT INTO `cities` VALUES (141, '济宁市', 370800, 370000);
INSERT INTO `cities` VALUES (142, '泰安市', 370900, 370000);
INSERT INTO `cities` VALUES (143, '威海市', 371000, 370000);
INSERT INTO `cities` VALUES (144, '日照市', 371100, 370000);
INSERT INTO `cities` VALUES (145, '临沂市', 371300, 370000);
INSERT INTO `cities` VALUES (146, '德州市', 371400, 370000);
INSERT INTO `cities` VALUES (147, '聊城市', 371500, 370000);
INSERT INTO `cities` VALUES (148, '滨州市', 371600, 370000);
INSERT INTO `cities` VALUES (149, '菏泽市', 371700, 370000);
INSERT INTO `cities` VALUES (150, '郑州市', 410100, 410000);
INSERT INTO `cities` VALUES (151, '开封市', 410200, 410000);
INSERT INTO `cities` VALUES (152, '洛阳市', 410300, 410000);
INSERT INTO `cities` VALUES (153, '平顶山市', 410400, 410000);
INSERT INTO `cities` VALUES (154, '安阳市', 410500, 410000);
INSERT INTO `cities` VALUES (155, '鹤壁市', 410600, 410000);
INSERT INTO `cities` VALUES (156, '新乡市', 410700, 410000);
INSERT INTO `cities` VALUES (157, '焦作市', 410800, 410000);
INSERT INTO `cities` VALUES (158, '濮阳市', 410900, 410000);
INSERT INTO `cities` VALUES (159, '许昌市', 411000, 410000);
INSERT INTO `cities` VALUES (160, '漯河市', 411100, 410000);
INSERT INTO `cities` VALUES (161, '三门峡市', 411200, 410000);
INSERT INTO `cities` VALUES (162, '南阳市', 411300, 410000);
INSERT INTO `cities` VALUES (163, '商丘市', 411400, 410000);
INSERT INTO `cities` VALUES (164, '信阳市', 411500, 410000);
INSERT INTO `cities` VALUES (165, '周口市', 411600, 410000);
INSERT INTO `cities` VALUES (166, '驻马店市', 411700, 410000);
INSERT INTO `cities` VALUES (167, '武汉市', 420100, 420000);
INSERT INTO `cities` VALUES (168, '黄石市', 420200, 420000);
INSERT INTO `cities` VALUES (169, '十堰市', 420300, 420000);
INSERT INTO `cities` VALUES (170, '宜昌市', 420500, 420000);
INSERT INTO `cities` VALUES (171, '襄阳市', 420600, 420000);
INSERT INTO `cities` VALUES (172, '鄂州市', 420700, 420000);
INSERT INTO `cities` VALUES (173, '荆门市', 420800, 420000);
INSERT INTO `cities` VALUES (174, '孝感市', 420900, 420000);
INSERT INTO `cities` VALUES (175, '荆州市', 421000, 420000);
INSERT INTO `cities` VALUES (176, '黄冈市', 421100, 420000);
INSERT INTO `cities` VALUES (177, '咸宁市', 421200, 420000);
INSERT INTO `cities` VALUES (178, '随州市', 421300, 420000);
INSERT INTO `cities` VALUES (179, '恩施土家族苗族自治州', 422800, 420000);
INSERT INTO `cities` VALUES (180, '长沙市', 430100, 430000);
INSERT INTO `cities` VALUES (181, '株洲市', 430200, 430000);
INSERT INTO `cities` VALUES (182, '湘潭市', 430300, 430000);
INSERT INTO `cities` VALUES (183, '衡阳市', 430400, 430000);
INSERT INTO `cities` VALUES (184, '邵阳市', 430500, 430000);
INSERT INTO `cities` VALUES (185, '岳阳市', 430600, 430000);
INSERT INTO `cities` VALUES (186, '常德市', 430700, 430000);
INSERT INTO `cities` VALUES (187, '张家界市', 430800, 430000);
INSERT INTO `cities` VALUES (188, '益阳市', 430900, 430000);
INSERT INTO `cities` VALUES (189, '郴州市', 431000, 430000);
INSERT INTO `cities` VALUES (190, '永州市', 431100, 430000);
INSERT INTO `cities` VALUES (191, '怀化市', 431200, 430000);
INSERT INTO `cities` VALUES (192, '娄底市', 431300, 430000);
INSERT INTO `cities` VALUES (193, '湘西土家族苗族自治州', 433100, 430000);
INSERT INTO `cities` VALUES (194, '广州市', 440100, 440000);
INSERT INTO `cities` VALUES (195, '韶关市', 440200, 440000);
INSERT INTO `cities` VALUES (196, '深圳市', 440300, 440000);
INSERT INTO `cities` VALUES (197, '珠海市', 440400, 440000);
INSERT INTO `cities` VALUES (198, '汕头市', 440500, 440000);
INSERT INTO `cities` VALUES (199, '佛山市', 440600, 440000);
INSERT INTO `cities` VALUES (200, '江门市', 440700, 440000);
INSERT INTO `cities` VALUES (201, '湛江市', 440800, 440000);
INSERT INTO `cities` VALUES (202, '茂名市', 440900, 440000);
INSERT INTO `cities` VALUES (203, '肇庆市', 441200, 440000);
INSERT INTO `cities` VALUES (204, '惠州市', 441300, 440000);
INSERT INTO `cities` VALUES (205, '梅州市', 441400, 440000);
INSERT INTO `cities` VALUES (206, '汕尾市', 441500, 440000);
INSERT INTO `cities` VALUES (207, '河源市', 441600, 440000);
INSERT INTO `cities` VALUES (208, '阳江市', 441700, 440000);
INSERT INTO `cities` VALUES (209, '清远市', 441800, 440000);
INSERT INTO `cities` VALUES (210, '东莞市', 441900, 440000);
INSERT INTO `cities` VALUES (211, '中山市', 442000, 440000);
INSERT INTO `cities` VALUES (212, '潮州市', 445100, 440000);
INSERT INTO `cities` VALUES (213, '揭阳市', 445200, 440000);
INSERT INTO `cities` VALUES (214, '云浮市', 445300, 440000);
INSERT INTO `cities` VALUES (215, '南宁市', 450100, 450000);
INSERT INTO `cities` VALUES (216, '柳州市', 450200, 450000);
INSERT INTO `cities` VALUES (217, '桂林市', 450300, 450000);
INSERT INTO `cities` VALUES (218, '梧州市', 450400, 450000);
INSERT INTO `cities` VALUES (219, '北海市', 450500, 450000);
INSERT INTO `cities` VALUES (220, '防城港市', 450600, 450000);
INSERT INTO `cities` VALUES (221, '钦州市', 450700, 450000);
INSERT INTO `cities` VALUES (222, '贵港市', 450800, 450000);
INSERT INTO `cities` VALUES (223, '玉林市', 450900, 450000);
INSERT INTO `cities` VALUES (224, '百色市', 451000, 450000);
INSERT INTO `cities` VALUES (225, '贺州市', 451100, 450000);
INSERT INTO `cities` VALUES (226, '河池市', 451200, 450000);
INSERT INTO `cities` VALUES (227, '来宾市', 451300, 450000);
INSERT INTO `cities` VALUES (228, '崇左市', 451400, 450000);
INSERT INTO `cities` VALUES (229, '海口市', 460100, 460000);
INSERT INTO `cities` VALUES (230, '三亚市', 460200, 460000);
INSERT INTO `cities` VALUES (231, '三沙市', 460300, 460000);
INSERT INTO `cities` VALUES (232, '儋州市', 460400, 460000);
INSERT INTO `cities` VALUES (233, '直辖市', 500100, 500000);
INSERT INTO `cities` VALUES (234, '成都市', 510100, 510000);
INSERT INTO `cities` VALUES (235, '自贡市', 510300, 510000);
INSERT INTO `cities` VALUES (236, '攀枝花市', 510400, 510000);
INSERT INTO `cities` VALUES (237, '泸州市', 510500, 510000);
INSERT INTO `cities` VALUES (238, '德阳市', 510600, 510000);
INSERT INTO `cities` VALUES (239, '绵阳市', 510700, 510000);
INSERT INTO `cities` VALUES (240, '广元市', 510800, 510000);
INSERT INTO `cities` VALUES (241, '遂宁市', 510900, 510000);
INSERT INTO `cities` VALUES (242, '内江市', 511000, 510000);
INSERT INTO `cities` VALUES (243, '乐山市', 511100, 510000);
INSERT INTO `cities` VALUES (244, '南充市', 511300, 510000);
INSERT INTO `cities` VALUES (245, '眉山市', 511400, 510000);
INSERT INTO `cities` VALUES (246, '宜宾市', 511500, 510000);
INSERT INTO `cities` VALUES (247, '广安市', 511600, 510000);
INSERT INTO `cities` VALUES (248, '达州市', 511700, 510000);
INSERT INTO `cities` VALUES (249, '雅安市', 511800, 510000);
INSERT INTO `cities` VALUES (250, '巴中市', 511900, 510000);
INSERT INTO `cities` VALUES (251, '资阳市', 512000, 510000);
INSERT INTO `cities` VALUES (252, '阿坝藏族羌族自治州', 513200, 510000);
INSERT INTO `cities` VALUES (253, '甘孜藏族自治州', 513300, 510000);
INSERT INTO `cities` VALUES (254, '凉山彝族自治州', 513400, 510000);
INSERT INTO `cities` VALUES (255, '贵阳市', 520100, 520000);
INSERT INTO `cities` VALUES (256, '六盘水市', 520200, 520000);
INSERT INTO `cities` VALUES (257, '遵义市', 520300, 520000);
INSERT INTO `cities` VALUES (258, '安顺市', 520400, 520000);
INSERT INTO `cities` VALUES (259, '毕节市', 520500, 520000);
INSERT INTO `cities` VALUES (260, '铜仁市', 520600, 520000);
INSERT INTO `cities` VALUES (261, '黔西南布依族苗族自治州', 522300, 520000);
INSERT INTO `cities` VALUES (262, '黔东南苗族侗族自治州', 522600, 520000);
INSERT INTO `cities` VALUES (263, '黔南布依族苗族自治州', 522700, 520000);
INSERT INTO `cities` VALUES (264, '昆明市', 530100, 530000);
INSERT INTO `cities` VALUES (265, '曲靖市', 530300, 530000);
INSERT INTO `cities` VALUES (266, '玉溪市', 530400, 530000);
INSERT INTO `cities` VALUES (267, '保山市', 530500, 530000);
INSERT INTO `cities` VALUES (268, '昭通市', 530600, 530000);
INSERT INTO `cities` VALUES (269, '丽江市', 530700, 530000);
INSERT INTO `cities` VALUES (270, '普洱市', 530800, 530000);
INSERT INTO `cities` VALUES (271, '临沧市', 530900, 530000);
INSERT INTO `cities` VALUES (272, '楚雄彝族自治州', 532300, 530000);
INSERT INTO `cities` VALUES (273, '红河哈尼族彝族自治州', 532500, 530000);
INSERT INTO `cities` VALUES (274, '文山壮族苗族自治州', 532600, 530000);
INSERT INTO `cities` VALUES (275, '西双版纳傣族自治州', 532800, 530000);
INSERT INTO `cities` VALUES (276, '大理白族自治州', 532900, 530000);
INSERT INTO `cities` VALUES (277, '德宏傣族景颇族自治州', 533100, 530000);
INSERT INTO `cities` VALUES (278, '怒江傈僳族自治州', 533300, 530000);
INSERT INTO `cities` VALUES (279, '迪庆藏族自治州', 533400, 530000);
INSERT INTO `cities` VALUES (280, '拉萨市', 540100, 540000);
INSERT INTO `cities` VALUES (281, '日喀则市', 540200, 540000);
INSERT INTO `cities` VALUES (282, '昌都市', 540300, 540000);
INSERT INTO `cities` VALUES (283, '林芝市', 540400, 540000);
INSERT INTO `cities` VALUES (284, '山南市', 540500, 540000);
INSERT INTO `cities` VALUES (285, '那曲市', 540600, 540000);
INSERT INTO `cities` VALUES (286, '阿里地区', 542500, 540000);
INSERT INTO `cities` VALUES (287, '西安市', 610100, 610000);
INSERT INTO `cities` VALUES (288, '铜川市', 610200, 610000);
INSERT INTO `cities` VALUES (289, '宝鸡市', 610300, 610000);
INSERT INTO `cities` VALUES (290, '咸阳市', 610400, 610000);
INSERT INTO `cities` VALUES (291, '渭南市', 610500, 610000);
INSERT INTO `cities` VALUES (292, '延安市', 610600, 610000);
INSERT INTO `cities` VALUES (293, '汉中市', 610700, 610000);
INSERT INTO `cities` VALUES (294, '榆林市', 610800, 610000);
INSERT INTO `cities` VALUES (295, '安康市', 610900, 610000);
INSERT INTO `cities` VALUES (296, '商洛市', 611000, 610000);
INSERT INTO `cities` VALUES (297, '兰州市', 620100, 620000);
INSERT INTO `cities` VALUES (298, '嘉峪关市', 620200, 620000);
INSERT INTO `cities` VALUES (299, '金昌市', 620300, 620000);
INSERT INTO `cities` VALUES (300, '白银市', 620400, 620000);
INSERT INTO `cities` VALUES (301, '天水市', 620500, 620000);
INSERT INTO `cities` VALUES (302, '武威市', 620600, 620000);
INSERT INTO `cities` VALUES (303, '张掖市', 620700, 620000);
INSERT INTO `cities` VALUES (304, '平凉市', 620800, 620000);
INSERT INTO `cities` VALUES (305, '酒泉市', 620900, 620000);
INSERT INTO `cities` VALUES (306, '庆阳市', 621000, 620000);
INSERT INTO `cities` VALUES (307, '定西市', 621100, 620000);
INSERT INTO `cities` VALUES (308, '陇南市', 621200, 620000);
INSERT INTO `cities` VALUES (309, '临夏回族自治州', 622900, 620000);
INSERT INTO `cities` VALUES (310, '甘南藏族自治州', 623000, 620000);
INSERT INTO `cities` VALUES (311, '西宁市', 630100, 630000);
INSERT INTO `cities` VALUES (312, '海东市', 630200, 630000);
INSERT INTO `cities` VALUES (313, '海北藏族自治州', 632200, 630000);
INSERT INTO `cities` VALUES (314, '黄南藏族自治州', 632300, 630000);
INSERT INTO `cities` VALUES (315, '海南藏族自治州', 632500, 630000);
INSERT INTO `cities` VALUES (316, '果洛藏族自治州', 632600, 630000);
INSERT INTO `cities` VALUES (317, '玉树藏族自治州', 632700, 630000);
INSERT INTO `cities` VALUES (318, '海西蒙古族藏族自治州', 632800, 630000);
INSERT INTO `cities` VALUES (319, '银川市', 640100, 640000);
INSERT INTO `cities` VALUES (320, '石嘴山市', 640200, 640000);
INSERT INTO `cities` VALUES (321, '吴忠市', 640300, 640000);
INSERT INTO `cities` VALUES (322, '固原市', 640400, 640000);
INSERT INTO `cities` VALUES (323, '中卫市', 640500, 640000);
INSERT INTO `cities` VALUES (324, '乌鲁木齐市', 650100, 650000);
INSERT INTO `cities` VALUES (325, '克拉玛依市', 650200, 650000);
INSERT INTO `cities` VALUES (326, '吐鲁番市', 650400, 650000);
INSERT INTO `cities` VALUES (327, '哈密市', 650500, 650000);
INSERT INTO `cities` VALUES (328, '昌吉回族自治州', 652300, 650000);
INSERT INTO `cities` VALUES (329, '博尔塔拉蒙古自治州', 652700, 650000);
INSERT INTO `cities` VALUES (330, '巴音郭楞蒙古自治州', 652800, 650000);
INSERT INTO `cities` VALUES (331, '阿克苏地区', 652900, 650000);
INSERT INTO `cities` VALUES (332, '克孜勒苏柯尔克孜自治州', 653000, 650000);
INSERT INTO `cities` VALUES (333, '喀什地区', 653100, 650000);
INSERT INTO `cities` VALUES (334, '和田地区', 653200, 650000);
INSERT INTO `cities` VALUES (335, '伊犁哈萨克自治州', 654000, 650000);
INSERT INTO `cities` VALUES (336, '塔城地区', 654200, 650000);
INSERT INTO `cities` VALUES (337, '阿勒泰地区', 654300, 650000);
INSERT INTO `cities` VALUES (338, '台北市', 710100, 710000);
INSERT INTO `cities` VALUES (339, '高雄市', 710200, 710000);
INSERT INTO `cities` VALUES (340, '台南市', 710300, 710000);
INSERT INTO `cities` VALUES (341, '台中市', 710400, 710000);
INSERT INTO `cities` VALUES (342, '南投县', 710600, 710000);
INSERT INTO `cities` VALUES (343, '基隆市', 710700, 710000);
INSERT INTO `cities` VALUES (344, '新竹市', 710800, 710000);
INSERT INTO `cities` VALUES (345, '嘉义市', 710900, 710000);
INSERT INTO `cities` VALUES (346, '新北市', 711100, 710000);
INSERT INTO `cities` VALUES (347, '宜兰县', 711200, 710000);
INSERT INTO `cities` VALUES (348, '新竹县', 711300, 710000);
INSERT INTO `cities` VALUES (349, '桃园市', 711400, 710000);
INSERT INTO `cities` VALUES (350, '苗栗县', 711500, 710000);
INSERT INTO `cities` VALUES (351, '彰化县', 711700, 710000);
INSERT INTO `cities` VALUES (352, '嘉义县', 711900, 710000);
INSERT INTO `cities` VALUES (353, '云林县', 712100, 710000);
INSERT INTO `cities` VALUES (354, '屏东县', 712400, 710000);
INSERT INTO `cities` VALUES (355, '台东县', 712500, 710000);
INSERT INTO `cities` VALUES (356, '花莲县', 712600, 710000);
INSERT INTO `cities` VALUES (357, '澎湖县', 712700, 710000);
INSERT INTO `cities` VALUES (358, '直辖市', 810100, 810000);
INSERT INTO `cities` VALUES (359, '直辖市', 820100, 820000);
INSERT INTO `cities` VALUES (360, '', 0, 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
